package com.zr.kucunkufangbiaoshi.controller.mapper;


import com.zr.kucunkufangbiaoshi.controller.pojo.WareHouseIdentify;
import com.zr.kucunkufangbiaoshi.controller.pojo.WareHouseIdentifySelectVo;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import java.util.List;


/**
 * Created by Administrator on 2019/7/16 0016.
 */
@Mapper
public interface WareHouseIdentifyMapper {
    /**
     * 分页
     * @param
     * @return
     */
    List<WareHouseIdentify> queryPage(WareHouseIdentifySelectVo wareHouseIdentifySelectVo);
    int queryCount(WareHouseIdentifySelectVo wareHouseIdentifySelectVo);
    @Insert("insert into warehouseidentify(code,name,remark,status) values(#{code},#{name},#{remark},#{status})")
    int add(WareHouseIdentify wareHouseIdentify);
    @Update("update warehouseidentify set status=#{status} where id=#{id}")
    int updateStatus(WareHouseIdentify wareHouseIdentify);
    @Select("select * from warehouseidentify where id=#{id}")
    WareHouseIdentify queryById(Integer id);
    @Update("update warehouseidentify set code=#{code},name=#{name},remark=#{remark} where id =#{id}")
    int update(WareHouseIdentify wareHouseIdentify);
}
